(4, 16) Downloads the chosen months final NAV's and updates Newmutnv.xls
(4, 17)
(4, 18)
(4, 19)
(5, 0) Author
(5, 1) PHILIP F. TROIANO
(5, 2)
(5, 4) 5
(5, 5) 8
(5, 6) 10
(5, 7) 300
(5, 8) 12
(5, 9) Result of ="set"
(5, 10)
(5, 11)
(5, 13)
(5, 14)
(5, 15)
(5, 16)
(5, 17)
(6, 0) Corporation:
(6, 1) PHILIP F. TROIANO
(6, 2)
(6, 4) 6
(6, 5) 8
(6, 6) 33
(6, 7) 262
(6, 8)
(6, 9)
(6, 10) set
(6, 11) ud01s.command
(7, 0) Creation Date:
(7, 1) "3/1/1993"
(7, 2)
(7, 4) 2
(7, 5) 280
(7, 6) 32
(7, 7)
(7, 8)
(7, 9) &Close
(7, 10)
(7, 11)
(8, 0)
(8, 1)
(8, 2)
(9, 0) auto_open
(9, 1) auto_open
(9, 2)
(9, 4) ud02.GetCommand
(10, 0) mco00s.MacroName
(10, 1) [NEWMUTNV.XLW]CISMNAV.XL
(10, 2) name of this document
(10, 4) Excelhlp.hlp!523
(10, 5)
(10, 6)
(10, 7)
(10, 8)
(10, 9) Command Window
(10, 10) 2
(10, 11)
(11, 0)
(11, 1)
(11, 2)
(11, 4) 5
(11, 5) 8
(11, 6) 10
(11, 7) 151
(11, 8)
(11, 9) &Execute Command:
(11, 10)
(11, 11)
(12, 0)
(12, 1) TRUE
(12, 2) delete this formula
(12, 4) 9
(12, 5) 8
(12, 6) 33
(12, 7) 262
(12, 8)
(12, 9)
(12, 10)
(12, 11) ud02s.command
(13, 0)
(13, 1) 9
(13, 2)
(13, 4) 1
(13, 5) 280
(13, 6) 8
(13, 7)
(13, 8)
(13, 9) &Run
(13, 10)
(13, 11)
(14, 0)
(14, 1) TRUE
(14, 2)
(14, 4) 2
(14, 5) 280
(14, 6) 32
(14, 7)
(14, 8)
(14, 9) &Cancel
(14, 10)
(14, 11)
(15, 0)
(15, 1)
(15, 2)
(15, 10) TRUE
(16, 0) auto_close
(16, 1) auto_close
(16, 2)
(17, 0)
(17, 1) TRUE
(17, 2)
(18, 0)
(18, 1) TRUE
(18, 2)
(19, 0)
(19, 1)
(19, 2)
(19, 4) DLG_Data
(19, 5)
(20, 0) ctrl-a
(20, 1) CIS MQINT Download
(20, 2) reads date input from dialog box calls prcomm for window and activates the prcomm script.
(20, 4) type
(20, 5) x
(20, 6) y
(20, 7) wide
(20, 8) high
(20, 9) text
(20, 10) init/result
(20, 11) names
(21, 0)
(21, 1) TRUE
(21, 2)
(21, 4)
(21, 5)
(21, 6)
(21, 7) 578
(21, 8) 316
(21, 9)
(21, 10)
(22, 0)
(22, 1) TRUE
(22, 2)
(22, 4) 5
(22, 5) 10
(22, 6) 6
(22, 9) Select the month and the year for which data is to be requested.
(22, 10)
(23, 0)
(23, 1) TRUE
(23, 2) selects the option button group cell for the month selection group
(23, 4) 14
(23, 5) 28
(23, 6) 35
(23, 7) 194
(23, 8) 220
(23, 9) Month
(23, 10)
(24, 0)
(24, 1) TRUE
(24, 2) clears the above selection
(24, 4) 11
(24, 10) 2
(25, 0)
(25, 1) TRUE
(25, 2) selects MKT index cell and clears it
(25, 4) 12
(25, 9) January
(25, 10) 1
(25, 11)
(26, 0)
(26, 1) TRUE
(26, 2)
(26, 4) 12
(26, 9) February
(26, 10) 2
(27, 0)
(27, 1) 23
(27, 2)
(27, 4) 12
(27, 9) March
(27, 10) 3
(28, 0)
(28, 1) TRUE
(28, 2) if the dialog box is cancelled then this braches to the alert and halts the macroelse if the cell contains data then the macro ic continued
(28, 4) 12
(28, 9) April
(28, 10) 4
(29, 0)
(29, 1) TRUE
(29, 2)
(29, 4) 12
(29, 9) May
(29, 10) 5
(30, 0)
(30, 1) TRUE
(30, 2)
(30, 4) 12
(30, 9) June
(30, 10) 6
(31, 0) Begin Prcomm
(31, 1) Begin Procomm
(31, 2)
(31, 4) 12
(31, 9) July
(31, 10) 7
(32, 0)
(32, 1) TRUE
(32, 2) checks for whether only market indexe values are requested
(32, 4) 12
(32, 9) August
(32, 10) 8
(33, 0)
(33, 1) TRUE
(33, 2) gets the number of the month selected and adds a zero if <10
(33, 4) 12
(33, 9) September
(33, 10) 9
(34, 0)
(34, 1) TRUE
(34, 2) gets the 2 digits for the selected year ie."92"
(34, 4) 12
(34, 9) October
(34, 10) 10
(35, 0)
(35, 1) TRUE
(35, 2) ,M,920215,920216
(35, 4) 12
(35, 9) November
(35, 10) 11
(36, 0)
(36, 1) TRUE
(36, 2)
(36, 4) 12
(36, 5)
(36, 6)
(36, 7)
(36, 8)
(36, 9) December
(36, 10) 12
(37, 0)
(37, 1) TRUE
(37, 2) only opens sheet if it is not already open
(37, 4) 14
(37, 5) 235
(37, 6) 35
(37, 7) 197
(37, 8) 95
(37, 9) Year
(37, 10)
(38, 0)
(38, 1) TRUE
(38, 2)
(38, 4) 11
(38, 10) 1
(39, 0)
(39, 1) TRUE
(39, 2) selects the whole sheet
(39, 4) 12
(39, 9) 1992
(39, 10) 1
(39, 11) 92
(40, 0)
(40, 1) TRUE
(40, 2) empties tempdat
(40, 4) 12
(40, 9) 1993
(40, 10) 2
(40, 11) 93
(41, 0)
(41, 1) TRUE
(41, 2) blocks error trapping
(41, 4) 12
(41, 9) 1994
(41, 10) 3
(41, 11) 94
(42, 0)
(42, 1) 9030
(42, 2) if Procomm WIn is open it sends the key sequence to start a macro if not it interrupts the macro. Pushing continue branches to the right step.
(42, 4) 12
(42, 5)
(42, 6)
(42, 7)
(42, 8)
(42, 9) 1995
(42, 10) 4
(42, 11) 95
(43, 0)
(43, 1) TRUE
(43, 2) reinstates error trapping
(43, 4) 13
(43, 5) 240
(43, 6) 150
(43, 7) 300
(43, 8) 20
(43, 9) Check for only Market Index Values
(43, 10) TRUE
(44, 0)
(44, 1) TRUE
(44, 2)
(44, 4) 1
(44, 5) 345
(44, 6) 200
(44, 7) 88
(44, 9) OK
(44, 10)
(45, 0)
(45, 1)
(45, 2)
(45, 4) 2
(45, 5) 345
(45, 6) 255
(45, 7) 88
(45, 8)
(45, 9) Cancel
(45, 10)
(46, 0) BeginPrcommIndex
(46, 1) BeginProcommIndex
(46, 2) Calls procom with the cismidx .wax script and only downloads the months Market Index values
(46, 4)
(46, 5)
(46, 6)
(46, 7)
(46, 8)
(46, 9)
(46, 10)
(47, 0)
(47, 1) TRUE
(47, 2) gets the number of the month selected and adds a zero if <10
(47, 4)
(47, 5)
(47, 6)
(47, 7)
(47, 8)
(47, 9)
(47, 10)
(48, 0)
(48, 1) TRUE
(48, 2) gets the 2 digits for the selected year ie."92"
(49, 0)
(49, 1) TRUE
(49, 2) concatenates M,year,month,15 in Mqint order
(50, 0)
(50, 1) TRUE
(50, 2)
(51, 0)
(51, 1) TRUE
(51, 2) only opens sheet if it is not already open
(52, 0)
(52, 1) TRUE
(52, 2)
(53, 0)
(53, 1) TRUE
(53, 2) selects the whole sheet
(54, 0)
(54, 1) TRUE
(54, 2) empties tempdat
(55, 0)
(55, 1) TRUE
(55, 2) blocks error trapping
(56, 0)
(56, 1) 11934
(56, 2) if Procomm WIn is open it sends the key sequence to start a macro if not it interrupts the macro. Pushing continue branches to the right step.
(57, 0)
(57, 1) TRUE
(57, 2) reinstates error trapping
(57, 4)
(57, 5)
(57, 6)
(57, 7)
(57, 8)
(57, 9)
(57, 10)
(57, 11)
(57, 13)
(57, 14)
(57, 15)
(57, 16)
(57, 17)
(57, 18)
(58, 0)
(58, 1) TRUE
(58, 2)
(59, 0)
(59, 1)
(59, 2)
(60, 0)
(60, 1)
(60, 2)
(61, 0)
(61, 1)
(61, 2)
(62, 0)
(62, 1)
(62, 2)
(63, 0) ctrl-z
(63, 1) CIS MQINT Parser
(63, 2) Parses financial data now in coumn B
(64, 0)
(64, 1) TRUE
(64, 2)
(65, 0)
(65, 1) TRUE
(65, 2) counts num of rows
(66, 0)
(66, 1) TRUE
(66, 2) sets up ref to first selection
(67, 0)
(67, 1) TRUE
(67, 2) selects the specified rows in the specified column
(68, 0)
(68, 1) ECHO(FALSE)
(68, 2) Screen updating off
(69, 0)
(69, 1) FALSE
(69, 2) More than one column?
(70, 0)
(70, 1) TRUE
(70, 2) Begins loop over the range
(71, 0)
(71, 1) TRUE
(71, 2) Selectls the next cell to parse
(72, 0) CellCont
(72, 1) ? I&Q020 -- Issue not found
(72, 2) Gets contents of active cell
(73, 0)
(73, 1) TRUE
(73, 2) Checks for separator
(73, 4)
(73, 5)
(73, 6)
(73, 7)
(73, 8)
(73, 9)
(73, 10)
(73, 11)
(73, 13)
(73, 14)
(73, 15)
(73, 16)
(73, 17)
(73, 18)
(74, 0) CellCont2
(74, 1) [? I&Q020 -- Issue not found.
(74, 2) Puts brackets around text
(75, 0) Parse Text
(75, 1) [?] [I&Q020] [--] [Issue] [not] [found.
(75, 2) Replaces separator with brackets
(76, 0)
(76, 1) TRUE
(76, 2) parses the data
(77, 0)
(77, 1) TRUE
(77, 2)
(78, 0)
(78, 1) TRUE
(78, 2)
(79, 0)
(79, 1) TRUE
(79, 2)
(79, 4)
(79, 5)
(79, 6)
(79, 7)
(79, 8)
(79, 9)
(79, 10)
(79, 11)
(79, 13)
(79, 14)
(79, 15)
(79, 16)
(79, 17)
(79, 18)
(80, 0) AlertArea
(80, 1) AlertArea
(80, 2)
(81, 0)
(81, 1) TRUE
(81, 2)
(82, 0)
(82, 1) TRUE
(82, 2)
(83, 0) ctrl-b
(83, 1) COLUMN.CALCULATION
(83, 2) Calc. min & end NAV & enters in cols G&H on data input sheet
(84, 0) Begin calc
(84, 1) *****ctrl-b
(84, 2)
(85, 0)
(85, 1) TRUE
(85, 2) counts num of rows
(86, 0)
(86, 1) TRUE
(86, 2) sets up ref to first selection
(87, 0)
(87, 1) TRUE
(87, 2) selects the specified rows in the specified column
(88, 0)
(88, 1) TRUE
(88, 2) fills the selected range with the -sum of the high NAV and the Min offset
(89, 0)
(89, 1) TRUE
(89, 2) selects the next column over
(90, 0)
(90, 1) TRUE
(90, 2) fills the selected range with the -sum of the high NAV and the End of month offset
(91, 0) ctrl-t
(91, 1) TRANSFER.DATA
(91, 2) transfers data to the monthly nav sheet
(92, 0)
(92, 1) TRUE
(92, 2)
(93, 0) Begin transfer
(93, 1) *****
(93, 2)
(94, 0)
(94, 1) TRUE
(94, 2) activates data input sheet AS LISTED IN THE RESULT CELL FROM THE THE INITIAL INPUT SCREEN
(95, 0)
(95, 1) TRUE
(95, 2) increments the row number varible by +1
(96, 0)
(96, 1) TRUE
(96, 2) selects R1C1 works down the column
(97, 0)
(97, 1) TRUE
(97, 2) gets the text in the active cell
(98, 0)
(98, 1) TRUE
(98, 2) counts num of characters in cell
(99, 0)
(99, 1) TRUE
(99, 2) tests for blank or single ":" and if so ends this section
(100, 0)
(100, 1) TRUE
(100, 2) check whether cis ticksymb has a space in it and branches to the correct place accordingly
(101, 0) delete space
(101, 1) TRUE
(101, 2) sets new name to dow & sp names because cis names not otherwise useable by macro
(102, 0)
(102, 1) TRUE
(102, 2)
(103, 0) cont transfer
(103, 1) TRUE
(103, 2) selects appropriate cells and reads datat into the correspnding variables
(104, 0) ticksymb repl
(104, 1) TRUE
(104, 2) "
(105, 0)
(105, 1) TRUE
(105, 2) "
(106, 0)
(106, 1) TRUE
(106, 2) "
(107, 0)
(107, 1) TRUE
(107, 2) "
(108, 0)
(108, 1) TRUE
(108, 2) "
(109, 0)
(109, 1) TRUE
(109, 2) "
(110, 0)
(110, 1) TRUE
(110, 2) "
(111, 0)
(111, 1) TRUE
(111, 2) "
(112, 0)
(112, 1) TRUE
(112, 2)
(113, 0)
(113, 1) TRUE
(113, 2) changes the cis date to excel format FOR THE FIRST OF THE MONTH SO THAT THIS DATE CAN BE USED TO LOCATE THE APPROPRIATE ROW WITH THE MATCH FUNCTION
(114, 0)
(114, 1) TRUE
(114, 2) activates the data output sheet
(115, 0)
(115, 1) TRUE
(115, 2) selects named range in mnthnav
(116, 0)
(116, 1) TRUE
(116, 2) selcts column of dates for the next sttements match comparison
(117, 0)
(117, 1) TRUE
(117, 2) selects data input row
(118, 0)
(118, 1) TRUE
(118, 2) writes new data to appropriate line
(119, 0)
(119, 1) TRUE
(119, 2) "
(120, 0)
(120, 1) TRUE
(120, 2) "
(121, 0)
(121, 1) TRUE
(121, 2)
(122, 0) End transfer
(122, 1) *****
(122, 2)
(123, 0)
(123, 1) EndCisMacro
(123, 2) ends macro and closes tempdata sheet with new name
(124, 1) TRUE
(124, 2) activates the tempdata sheet
(125, 1) TRUE
(125, 2) renames the sheet to the current months date
(.txt)